You are here: Using Auxiliary Tools > Power Tools > ProActiveX > Worksheets
Many of the worksheets in ProActiveX have drop-down lists which make it easier to fill in the required data. In all cases, the value you select will be inserted into the selected cell or range of cells. However, the assigned macros do not prevent you from selecting a different column than the one with the drop-down used.
Using a combo box with a pre-defined list is one way to ensure consistency in the data. In most cases, the numeric value of the list selection is temporarily recorded on the hidden sheet (named Hidden Sheet). On the Simulation Options sheet, instead of filling in a cell or range, the value shows in the drop-down box itself and the numeric value is hidden in the cell behind it.
The Simulation Options sheet also contains several check boxes and a text box. The values for the check boxes are hidden in the cells behind them. The method used for hiding the values is simply to make the text color the same as the background color.
A few of the worksheets have data columns defined for methods which have not yet been implemented in the ProModel Data Object. These columns have been included to acknowledge that these elements were not forgotten when ProActiveX was created–these data elements will be enabled in future releases of ProModel.
The Shift Assignments worksheet has a button to the far right labeled Shift Editor. Clicking on this button will show the Shift Editor, just like when you invoke the menu call from your default ProModel Corporation product.
The General Info worksheet has a Browse... button that uses the Microsoft Common Dialog to display a file selection window.
Several worksheets have comments in the cells of the title rows. These comments are included to give you important information about the data contained in that column–like limitations or formatting requirements.
In each worksheet where the data columns go beyond the right-hand border of a single screen, separate panes have been created and ‘frozen’ to allow you to scroll through the columns without moving the column that identifies the record. The title rows have also been frozen, so that the user can scroll down the sheet without losing sight of the titles.
In each worksheet, title labels spanning more than one column indicate that all the columns beneath that title pertain to that type of information. For example, on the Resources worksheet, there are several columns for downtime data which have duplicate titles, but different section labels. In some cases, the labels are used merely to make the titles easier to read.